package cn.gson.boot.model.mapper;

import cn.gson.boot.model.pojos.Jiaofujihua;
import cn.gson.boot.model.pojos.Jiaofujihuaxiangqing;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface JiaoFuJiHuaXiangQingMapper {
    //根据订单id查询交付计划详情
    public List<Jiaofujihuaxiangqing> selectJJXQbyDdId(Integer ddId);

    //根据交计id找到交计详情
    public List<Jiaofujihuaxiangqing> ckJJXQbyjjId(Integer jjId);

     //根据订单id和产品从表id找到 交付计划状态为已交付的交计详情产品的数量
    public Integer selectJJXQandYJFByddId(@Param("ddId") Integer ddId,
                                                             @Param("producttId") Integer producttId);

}
